Stored Procedures [dbo].[asi_GroupMembershipCount]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@groupkeyuniqueidentifier16
SQL Script
CREATE PROCEDURE [dbo].[asi_GroupMembershipCount]
    @groupkey uniqueidentifier
    AS
BEGIN
    SELECT COUNT(1) AS MemberCount
    FROM GroupMember
    WHERE GroupKey=@groupkey
END

GO
Uses